insert into asm_anagrafe_sito_ue
select distinct 0,trim(sog_codfis),'' sog_pariva,
max(sog_ragsoc),max(sog_tel),max(sog_numcell),max(sog_fax),max(sog_email),'' PASSWORD,'F',max(sog_id),'',''
from sic4u_ambUE.soggetto
where  SOG_FLPFG = '0'  and az_id = '01' and trim(sog_CODFIS) is not null

GROUP BY trim(sog_CODFIS)











